Summing amounts in reports

In the example above, each Count row includes a sum of the Amount for that line. This happens automatically if your subtotaled query has a Display Property that includes the words Amount or Amt (the property name is not case-sensitive). You can sum other numerical display properties by giving it an Alias on the Display tab that contains Amount or Amt.

For example, if your subtotaled query includes the CsOrders.Balance property, you can sum the balance for any Count rows by changing the Alias to Balance Amt or simply Amount – both variations work.